﻿using Ledict.ConditionExtract.Common;
using Ledict.ConditionExtract.Model;
using Ledict.Core.Data;
using System;
using System.Collections.Generic;
using System.Data;
using System.Data.Common;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace Ledict.ConditionExtract.DAL
{
    /// <summary>
    /// 对地域表操作的相关信息
    /// </summary>
    public class SYS_DistrictDAL
    {

        /// <summary>
        /// 获取地域表的省信息
        /// </summary>
        /// <returns></returns>
        public List<SYS_District> GetDistrict()
        {
            return SqlManage.sqlServerJudgeDocSystem.Select<SYS_District>().Where(x => x.DT_Level == "1").OrderBy(x=>x.DT_SerialNumb).ToList();
            //string sql = " select DT_ID,DT_Name from SYS_District where DT_Level in(1,2)  ";
            //return SqlManage.GetDataTableBySqlCondition(sql, DbName);
        }
    }
}
